This readme file was generated on 2025-08-22 by Juan Declet-Barreto & Amanda Fencl.

<!---This readme template was derived from Cornell University Data Services: https://data.research.cornell.edu/data-management/sharing/readme/--->

# GENERAL INFORMATION

## Title of Dataset: Subsidized Housing and Heat Alerts Analysis Merged Datasets and Summary Spreadsheets

## Author/Principal Investigator Information
Name: Juan Declet-Barreto

ORCID: 0000-0001-7101-394X

Institution: Union of Concerned Scientists

Address: 1825 K St. NW, Suite 800, Washington, DC, 20006

Email: jdeclet-barreto@ucs.org

## Author/Associate or Co-investigator Information
Name: Amanda Fencl

ORCID: 0000-0002-1914-0930

Institution: Union of Concerned Scientists

Address: 2001 Addison Street, Suite 200, Berkeley, CA 94704

Email: afencl@ucs.org

## Author/Associate or Co-investigator Information
Name: Rachel Cleetus

ORCID: 0000-0003-3026-4077

Institution: Union of Concerned Scientists

Address: Two Brattle Square, Cambridge, MA 02138-3780 

Email: rcleetus@ucs.org

## Author/Associate or Co-investigator Information
Name: Zoe Middleton

ORCID: N/A

Institution: Union of Concerned Scientists

Address:  1825 K St. NW, Suite 800, Washington, DC, 20006

Email: zmiddleton@ucs.org

## Author/Associate or Co-investigator Information
Name: Avery Kaplan

ORCID: N/A

Institution: Union of Concerned Scientists

Address: 1825 K St. NW, Suite 800, Washington, DC, 20006

Email: kaplanavery@gmail.com


## Date of data collection: 
January 2025 - August 2025

## Geographic location of data collection:
The data collected cover all states and territories of the United States.

## Information about funding sources that supported the collection of the data:

# SHARING/ACCESS INFORMATION

## Licenses/restrictions placed on the data:  
This dataset is made available under the Creative Commons Attribution-NonCommercial 4.0 International License: https://creativecommons.org/licenses/by-nc/4.0/

## Links to publications that cite or use the data: 
Declet-Barreto, J., A. Fencl, R. Cleetus, Z. Middleton, and A. Kaplan. 2025. Colliding Crises: The Dangers of Extreme Heat in Affordable Housing. Union of Concerned Scientists. https://doi.org/10.47923/2025.16006

## Links to other publicly accessible locations of the data:

https://doi.org/10.7910/DVN/X9HZDW

## Links/relationships to ancillary data sets:

This dataset was derived from the following datasets:
1. Durst, Noah J. 2025. “Mapping Manufactured Housing.” Version 1. Inter-university Consortium for Political and Social Research [distributor], January 27. https://doi.org/10.3886/E216681V1.
2. U.S. Department of Housing and Urban Development’s Office of Policy Development and Research. n.d. “Picture of Subsidized Housing (2024).” HUD User. https://www.huduser.gov/portal/datasets/assthsg.html.
3. HUD. 2025. “National Low Income Housing Tax Credit (LIHTC) Database.” May 8. https://www.huduser.gov/portal/datasets/lihtc/property.html.
4. Union of Concerned Scientists. 2025. “Danger Season 2024 Alerts.”

## Recommended citation for this dataset: 
Declet-Barreto, Juan; Fencl, Amanda L; Cleetus, Rachel; Zoe Middleton; Avery Kaplan, 2025, "Colliding Crises: The Dangers of Extreme Heat in Affordable Housing", https://doi.org/10.7910/DVN/X9HZDW, Harvard Dataverse

# DATA & FILE OVERVIEW

## File List: 
  * POSH_and_danger_season_data.gpkg - This dataset contains data from the Picture of Subsidized Households (POSH) dataset merged with Danger Season 2024 heat alerts. This dataset was subset to generate the danger_season_2024_heat_alerts_and_public_housing_summary.xlsx and danger_season_2024_heat_alerts_and_non_PH_subsidized_housing_summary.xlsx spreadsheets.
  * manufactured_housing_and_danger_season_data.gpkg - This dataset contains data from the Mapping Manufactured Housing dataset merged with Danger Season 2024 heat alerts. This dataset was subset to generate the danger_season_2024_heat_alerts_and_manufactured_housing_summary.xlsx spreadsheet.
  * LIHTC_and_danger_season_data.gpkg - This dataset contains data from the Low Income Housing Tax Credit (LIHTC) Database dataset merged with Danger Season 2024 heat alerts. This dataset was subset to generate the danger_season_2024_heat_alerts_and_LIHTC_housing_summary.xlsx spreadsheet.
  * danger_season_2024_heat_alerts_and_public_housing_summary.xlsx - This spreadsheet contains national and state-level summaries of frequencies of public housing developments and selected socio-demographic characteristics of its residents by the frequency of heat alerts during the 2024 Danger Season. This file was generated based on the POSH_and_danger_season_data.gpkg GeoPackage.
  * danger_season_2024_heat_alerts_and_project-based_subsidized_housing_summary.xlsx - This spreadsheet contains national and state-level summaries of frequencies of project-based housing subsidized housing developments and selected socio-demographic characteristics of its residents by the frequency of heat alerts during the 2024 Danger Season. This file was generated based on the POSH_and_danger_season_data.gpkg GeoPackage.
  * danger_season_2024_heat_alerts_and_MH_summary.xlsx - This spreadsheet contains national and state-level summaries of frequencies of manufactured housing developments by the frequency of heat alerts during the 2024 Danger Season. This file was generated based on the manufactured_housing_and_danger_season_data.gpkg GeoPackage.
  * danger_season_2024_heat_alerts_and_LIHTC_housing_summary.xlsx - This spreadsheet contains national and state-level summaries of frequencies of Low Income Housing Tax Credit (LIHTC) developments by the frequency of heat alerts during the 2024 Danger Season. This file was generated based on the LIHTC_and_danger_season_data.gpkg GeoPackage.


## Relationship between files, if important: 

## Additional related data collected that was not included in the current data package: 

## Are there multiple versions of the dataset? No
If yes, name of file(s) that was updated: N/A

Why was the file updated? N/A

When was the file updated? N/A


# METHODOLOGICAL INFORMATION

## Description of methods used for collection/generation of data: 
This subsection does not apply b/c the methods for collecting the data consisted only of downloading data.

## Methods for processing the data: 
See Technical Appendix for more information on data processing

## Instrument- or software-specific information needed to interpret the data: 
All data were entered, processed, and mapped in R 4.5.1. 
The following R packages were used to generate all datasets and figures:
* Barrett, Tyson, Matt Dowle, Arun Srinivasan, et al. 2025. Data.Table: Extension of `data.Frame`. https://r-datatable.com.
* Pebesma, Edzer. 2025. Sf: Simple Features for R. https://r-spatial.github.io/sf/.
* Pebesma, Edzer, and Roger Bivand. 2023. Spatial Data Science: With Applications in R. Chapman and Hall/CRC. https://doi.org/10.1201/9780429459016.
* Spinu, Vitalie, Garrett Grolemund, and Hadley Wickham. 2024. Lubridate: Make Dealing with Dates a Little Easier. https://lubridate.tidyverse.org.
* Wickham, Hadley. 2023. Stringr: Simple, Consistent Wrappers for Common String Operations. https://stringr.tidyverse.org.
* Wickham, Hadley, Winston Chang, Lionel Henry, et al. 2025. Ggplot2: Create Elegant Data Visualisations Using the Grammar of Graphics. https://ggplot2.tidyverse.org.
* Wickham, Hadley, Romain François, Lionel Henry, Kirill Müller, and Davis Vaughan. 2023. Dplyr: A Grammar of Data Manipulation. https://dplyr.tidyverse.org.
* Wickham, Hadley, and Lionel Henry. 2025. Purrr: Functional Programming Tools. https://purrr.tidyverse.org/.
* Wickham, Hadley, Davis Vaughan, and Maximilian Girlich. 2024. Tidyr: Tidy Messy Data. https://tidyr.tidyverse.org.
* Xie, Yihui. 2014. “Knitr: A Comprehensive Tool for Reproducible Research in R.” In Implementing Reproducible Computational Research, edited by Victoria Stodden, Friedrich Leisch, and Roger D. Peng. Chapman and Hall/CRC.
* Xie, Yihui. 2015. Dynamic Documents with R and Knitr. 2nd ed. Chapman and Hall/CRC. https://yihui.org/knitr/.
* Zhu, Hao. 2024. kableExtra: Construct Complex Table with Kable and Pipe Syntax. http://haozhu233.github.io/kableExtra/.


Preliminary mapping and data exploration were done in QGIS 3.22.
## Standards and calibration information, if appropriate: N/A

## Environmental/experimental conditions: N/A

## Describe any quality-assurance procedures performed on the data: 
Invalid or missing latitude/longitude coordinates for POSH and LIHTC data were filled in as described in methods section.
The socio-demographic data attached to the POSH dataset had many suppressed values. We assessed the completeness of these data items, whi
## People involved with sample collection, processing, analysis and/or submission: N/A

# DATA-SPECIFIC INFORMATION FOR: POSH_and_danger_season_data.gpkg
Number of variables: 92
Number of cases/rows: 29,142

Variable List:
All variables in the source Picture of Subsidized Households (POSH) dataset are included as is in this dataset. See the POSH Database data dictionary at https://www.huduser.gov/portal/datasets/pictures/dictionary_2024.pdf for the definitions for those variables.

The following variables were generated and attached to this dataset: 
* ds2023_fire_weather - Total frequency of fire alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_flood - Total frequency of flood alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_heat - Total frequency of heat alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_storm - Total frequency of storm alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_heat_cat - Recoded binned category for ds2023_heat. Character.
* ds2024_fire_weather - Total frequency of fire alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_flood - Total frequency of flood alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_heat - Total frequency of heat alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_storm - Total frequency of storm alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_heat_cat - Recoded binned category for ds2024_heat. Character.
* ds2025_fire_weather - Total frequency of fire alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_flood - Total frequency of flood alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_heat - Total frequency of heat alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds_2025_aqi_alert - Total frequency of days with a PM2.5 Air Quality Index (AQI) that equals or exceeds 100 (Unhealthy for Sensitive Groups) during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located.
* ds2025_storm - Total frequency of storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located.
* ds2025_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_heat_cat - Recoded binned category for ds2025_heat.
* ds_2023_2024_heat_mean - Average frequency of heat alerts during the 2023 and 2024 Danger Seasons in the county where subsidized housing development is located. Numeric.

# DATA-SPECIFIC INFORMATION FOR: MH_and_danger_season_data.gpkg
Number of variables: 25
Number of cases/rows: 1,929,601

Variable List:
All variables in the source manufactured housing dataset are included as is in this dataset. See the Mapping Manufactured  Housing dataset README file at https://www.openicpsr.org/openicpsr/project/216681/version/V2/view for the definitions for those variables.

The following variables were generated and attached to this dataset:

* ds2023_fire_weather - Total frequency of fire alerts during the 2023 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2023_flood - Total frequency of flood alerts during the 2023 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2023_heat - Total frequency of heat alerts during the 2023 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2023_storm - Total frequency of storm alerts during the 2023 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2023_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2023 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2023_heat_cat - Recoded binned category for ds2023_heat. Character.
* ds2024_fire_weather - Total frequency of fire alerts during the 2024 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2024_flood - Total frequency of flood alerts during the 2024 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2024_heat - Total frequency of heat alerts during the 2024 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2024_storm - Total frequency of storm alerts during the 2024 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2024_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2024 Danger Season in the county where manufactured housing development is located. Numeric.
* ds2024_heat_cat - Recoded binned category for ds2024_heat. Character.
* ds2025_fire_weather - Total frequency of fire alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located. Numeric.
* ds2025_flood - Total frequency of flood alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located. Numeric.
* ds2025_heat - Total frequency of heat alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located. Numeric.
* ds_2025_aqi_alert - Total frequency of days with a PM2.5 Air Quality Index (AQI) that equals or exceeds 100 (Unhealthy for Sensitive Groups) during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located.
* ds2025_storm - Total frequency of storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located.
* ds2025_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where manufactured housing development is located. Numeric.
* ds2025_heat_cat - Recoded binned category for ds2025_heat.
* ds_2023_2024_heat_mean - Average frequency of heat alerts during the 2023 and 2024 Danger Seasons in the county where manufactured housing development is located. Numeric.

# DATA-SPECIFIC INFORMATION FOR: LIHTC_and_danger_season_data.gpkg
Number of variables: 103
Number of cases/rows: 52,404

Variable List:
All variables in the source LIHTC dataset are included as is in this dataset. See the LIHTC Database data dictionary at https://www.huduser.gov/portal/datasets/lihtc/property.html for the definitions for those variables.

The following variables were generated and attached to this dataset:

* ds2023_fire_weather - Total frequency of fire alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_flood - Total frequency of flood alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_heat - Total frequency of heat alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_storm - Total frequency of storm alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2023 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2023_heat_cat - Recoded binned category for ds2023_heat. Character.
* ds2024_fire_weather - Total frequency of fire alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_flood - Total frequency of flood alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_heat - Total frequency of heat alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_storm - Total frequency of storm alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2024 Danger Season in the county where subsidized housing development is located. Numeric.
* ds2024_heat_cat - Recoded binned category for ds2024_heat. Character.
* ds2025_fire_weather - Total frequency of fire alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_flood - Total frequency of flood alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_heat - Total frequency of heat alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds_2025_aqi_alert - Total frequency of days with a PM2.5 Air Quality Index (AQI) that equals or exceeds 100 (Unhealthy for Sensitive Groups) during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located.
* ds2025_storm - Total frequency of storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located.
* ds2025_total - Total frequency of fire weather, flood, heat, and storm alerts during the 2025 Danger Season (from 1 May 2025 - 25 July 2025) in the county where subsidized housing development is located. Numeric.
* ds2025_heat_cat - Recoded binned category for ds2025_heat.
* ds_2023_2024_heat_mean - Average frequency of heat alerts during the 2023 and 2024 Danger Seasons in the county where subsidized housing development is located. Numeric.
* trgt_pop_recode - Recode of trgt_pop in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_pop and are not reported in our research. Numeric.
* trgt_fam_recode - Recode of trgt_fam in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_fam and are not reported in our research.  Numeric.
* trgt_eld_recode - Recode of trgt_eld in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_eld and are not reported in our research.  Numeric.
* trgt_dis_recode - Recode of trgt_dis in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_dis and are not reported in our research.  Numeric.
* trgt_hom_recode - Recode of trgt_hom in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_hom and are not reported in our research.  Numeric.
* trgt_other_recode - Recode of trgt_other in LIHTC source data. The LIHTC source data values are 1 = Yes, 2= No, 0 or blank = NA. These were recoded as 1 = 1, 2 = 0, 0 = 0, and NA = NA. The recoded values were used to assess data completeness of trgt_other and are not reported in our research.  Numeric.

Missing data codes: <list code/symbol and definition>
* Missing data are coded as NA.

Specialized formats or other abbreviations used: 
* File is in the GeoPackage format, which can be opened in current desktop or command-line GIS software such as QGIS, R, and ArcGIS Pro.

# DATA-SPECIFIC INFORMATION FOR: danger_season_2024_heat_alerts_and_public_housing_summary.xlsx 
This spreadsheet contains four tabs with the following variables:
* heat in PH  (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Public Housing Developments - Total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of People in Public Housing - Total frequency of people living in public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Total Public Housing Units - Total frequency of public housing units by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All Public Housing Developments - Percentage of total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All People in Public Housing Developments - Percentage of total frequency of people living in public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of Total Public Housing Units - Percentage of total frequency of public housing units by binned frequency of heat alerts during the 2024 Danger Season at the national level

* heat in PH - (state)
  * state - two-letter abbreviation for state
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Public Housing Developments - Total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of People in Public Housing - Total frequency of people living in public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Total Public Housing Units - Total frequency of public housing units by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All Public Housing Developments - Percentage of total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All People in Public Housing Developments - Percentage of total frequency of people living in public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of Total Public Housing Units - Percentage of total frequency of public housing units by binned frequency of heat alerts during the 2024 Danger Season at the state level

* heat & SES in PH - (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Public Housing Developments - Total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All Public Housing Developments - Percentage of total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. People of Color (mean, 87% reporting) - Average percent of households in which the race of the head of household is Black, Native American, or Asian or Pacific Islander, or the ethnicity is Hispanic by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Black (mean, 70% reporting) - Average percent of households in which the race of the head of household is Black and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Native American (mean, 24% reporting) - Average percent of households in which the race of the head of household is Native American or Native Alaskan and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Asian (mean, 30% reporting) - Average percent of households in which the race of the head of household is Asian or Pacific Islander and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Hispanic (mean, 87% reporting) - Average percent of households in which the ethnicity of the head of household is  Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level	
  * Per. Overhoused (mean, 48% reporting) - Average percent of households with more bedrooms than people by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. 62+ Years of Age (mean, 86% reporting) - Average percent of households in which the older of the household head or spouse is age 62 or older by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. 85+ Years of Age (mean, 66% reporting) - Average percent of households in which the older of the household head or spouse is age 85 or older by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Rent Per Month (mean, 87% reporting) - Average of the average gross household contribution towards rent per month by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Female Head of Household (mean, 87% reporting) Average percent of households headed by a female by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Female HH with Children (mean, 46% reporting) - Average percent of households headed by a female with children by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HHs with Welfare as Majority of Income (mean, 31% reporting) - Average percent of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance) by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HHs with Wages as Majority of Income (mean, 66% reporting) Average percent of households where the majority of household income is derived from some other source (other than wage and welfare) by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of Persons Living with Disability (mean, 87% reporting) - Average percentage of all persons in assisted households who have a disability by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HH with Utility Allowance (mean, 59% reporting) - Average percentage of households that receive a non-zero utility allowance payment by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Utility Allowance (mean, 59% reporting) - Average of the average utility allowance among households who have it (in $ per month) by binned frequency of heat alerts during the 2024 Danger Season at the national level

* heat & SES in PH - (state)
  * state - two-letter abbreviation for state
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Public Housing Developments - Total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All Public Housing Developments - Percentage of total frequency of public housing developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. People of Color (mean, 87% reporting) - Average percent of households in which the race of the head of household is Black, Native American, or Asian or Pacific Islander, or the ethnicity is Hispanic by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Black (mean, 70% reporting) - Average percent of households in which the race of the head of household is Black and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Native American (mean, 24% reporting) - Average percent of households in which the race of the head of household is Native American or Native Alaskan and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Asian (mean, 30% reporting) - Average percent of households in which the race of the head of household is Asian or Pacific Islander and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Hispanic (mean, 87% reporting) - Average percent of households in which the ethnicity of the head of household is  Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level	
  * Per. Overhoused (mean, 48% reporting) - Average percent of households with more bedrooms than people by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. 62+ Years of Age (mean, 86% reporting) - Average percent of households in which the older of the household head or spouse is age 62 or older by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. 85+ Years of Age (mean, 66% reporting) - Average percent of households in which the older of the household head or spouse is age 85 or older by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Rent Per Month (mean, 87% reporting) - Average of the average gross household contribution towards rent per month by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Female Head of Household (mean, 87% reporting) Average percent of households headed by a female by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Female HH with Children (mean, 46% reporting) - Average percent of households headed by a female with children by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HHs with Welfare as Majority of Income (mean, 31% reporting) - Average percent of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance) by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HHs with Wages as Majority of Income (mean, 66% reporting) Average percent of households where the majority of household income is derived from some other source (other than wage and welfare) by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of Persons Living with Disability (mean, 87% reporting) - Average percentage of all persons in assisted households who have a disability by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HH with Utility Allowance (mean, 59% reporting) - Average percentage of households that receive a non-zero utility allowance payment by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Utility Allowance (mean, 59% reporting) - Average of the average utility allowance among households who have it (in $ per month) by binned frequency of heat alerts during the 2024 Danger Season at the state level

# DATA-SPECIFIC INFORMATION FOR: danger_season_2024_heat_alerts_and_project-based_subsidized_housing_summary.xlsx 
This spreadsheet contains four tabs with the following variables:
* heat in PB  (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Project-based Subsidized Housing Developments - Total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of People in Project-based Subsidized Housing Developments - Total frequency of people living in project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Total Project-based Subsidized Housing Units - Total frequency of project-based housing subsidized units by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All Project-based Subsidized Housing Developments - Percentage of total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All People in Project-based Subsidized Housing Developments - Percentage of total frequency of people living in project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of Total Project-based Subsidized Housing Units - Percentage of total frequency of project-based housing subsidized units by binned frequency of heat alerts during the 2024 Danger Season at the national level

* heat in PB - (state)
  * state - two-letter abbreviation for state
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Public Housing Developments - Total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of People in Public Housing - Total frequency of people living in project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Total Public Housing Units - Total frequency of project-based housing subsidized units by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All Public Housing Developments - Percentage of total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All People in Public Housing Developments - Percentage of total frequency of people living in project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of Total Public Housing Units - Percentage of total frequency of project-based housing subsidized units by binned frequency of heat alerts during the 2024 Danger Season at the state level

* heat & SES in PB - (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Public Housing Developments - Total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All Public Housing Developments - Percentage of total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. People of Color (mean, 87% reporting) - Average percent of households in which the race of the head of household is Black, Native American, or Asian or Pacific Islander, or the ethnicity is Hispanic by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Black (mean, 70% reporting) - Average percent of households in which the race of the head of household is Black and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Native American (mean, 24% reporting) - Average percent of households in which the race of the head of household is Native American or Native Alaskan and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Asian (mean, 30% reporting) - Average percent of households in which the race of the head of household is Asian or Pacific Islander and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Hispanic (mean, 87% reporting) - Average percent of households in which the ethnicity of the head of household is  Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the national level	
  * Per. Overhoused (mean, 48% reporting) - Average percent of households with more bedrooms than people by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. 62+ Years of Age (mean, 86% reporting) - Average percent of households in which the older of the household head or spouse is age 62 or older by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. 85+ Years of Age (mean, 66% reporting) - Average percent of households in which the older of the household head or spouse is age 85 or older by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Rent Per Month (mean, 87% reporting) - Average of the average gross household contribution towards rent per month by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Female Head of Household (mean, 87% reporting) Average percent of households headed by a female by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. Female HH with Children (mean, 46% reporting) - Average percent of households headed by a female with children by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HHs with Welfare as Majority of Income (mean, 31% reporting) - Average percent of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance) by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HHs with Wages as Majority of Income (mean, 66% reporting) Average percent of households where the majority of household income is derived from some other source (other than wage and welfare) by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of Persons Living with Disability (mean, 87% reporting) - Average percentage of all persons in assisted households who have a disability by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of HH with Utility Allowance (mean, 59% reporting) - Average percentage of households that receive a non-zero utility allowance payment by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Utility Allowance (mean, 59% reporting) - Average of the average utility allowance among households who have it (in $ per month) by binned frequency of heat alerts during the 2024 Danger Season at the national level

* heat & SES in PB - (state)
  * state - two-letter abbreviation for state
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Frequency of Public Housing Developments - Total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of All Public Housing Developments - Percentage of total frequency of project-based housing subsidized developments by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. People of Color (mean, 87% reporting) - Average percent of households in which the race of the head of household is Black, Native American, or Asian or Pacific Islander, or the ethnicity is Hispanic by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Black (mean, 70% reporting) - Average percent of households in which the race of the head of household is Black and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Native American (mean, 24% reporting) - Average percent of households in which the race of the head of household is Native American or Native Alaskan and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Asian (mean, 30% reporting) - Average percent of households in which the race of the head of household is Asian or Pacific Islander and the ethnicity is not Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Hispanic (mean, 87% reporting) - Average percent of households in which the ethnicity of the head of household is  Hispanic, by binned frequency of heat alerts during the 2024 Danger Season at the state level	
  * Per. Overhoused (mean, 48% reporting) - Average percent of households with more bedrooms than people by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. 62+ Years of Age (mean, 86% reporting) - Average percent of households in which the older of the household head or spouse is age 62 or older by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. 85+ Years of Age (mean, 66% reporting) - Average percent of households in which the older of the household head or spouse is age 85 or older by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Rent Per Month (mean, 87% reporting) - Average of the average gross household contribution towards rent per month by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Female Head of Household (mean, 87% reporting) Average percent of households headed by a female by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. Female HH with Children (mean, 46% reporting) - Average percent of households headed by a female with children by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HHs with Welfare as Majority of Income (mean, 31% reporting) - Average percent of households where the majority of household income is derived from welfare (TANF, General Assistance, or Public Assistance) by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HHs with Wages as Majority of Income (mean, 66% reporting) Average percent of households where the majority of household income is derived from some other source (other than wage and welfare) by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of Persons Living with Disability (mean, 87% reporting) - Average percentage of all persons in assisted households who have a disability by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Per. of HH with Utility Allowance (mean, 59% reporting) - Average percentage of households that receive a non-zero utility allowance payment by binned frequency of heat alerts during the 2024 Danger Season at the state level
  * Utility Allowance (mean, 59% reporting) - Average of the average utility allowance among households who have it (in $ per month) by binned frequency of heat alerts during the 2024 Danger Season at the state level

# DATA-SPECIFIC INFORMATION FOR: danger_season_2024_heat_alerts_and_manufactured_housing_summary.xlsx 
This spreadsheet contains two tabs with the following variables:
* heat in MH  (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of Manufactured Housing Units - Total frequency of manufactured housing units by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All Manufactured Housing Units - Percentage of total frequency of manufactured housing units by binned frequency of heat alerts during the 2024 Danger Season at the national level
 
* heat in MH - (state)
   * state - two-letter abbreviation for state
   * Frequency of Manufactured Housing Units - Total frequency of manufactured housing units by binned frequency of heat alerts during the 2024 Danger Season at the state level
   * Per. of All Manufactured Housing Units - Percentage of total frequency of manufactured housing units by binned frequency of heat alerts during the 2024 Danger Season at the state level

# DATA-SPECIFIC INFORMATION FOR: danger_season_2024_heat_alerts_and_LIHTC_housing_summary.xlsx 
This spreadsheet contains two tabs with the following variables:
* heat in LIHTC  (nat'l)
  * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Frequency of LIHTC Projects - Total frequency of LIHTC projects by binned frequency of heat alerts during the 2024 Danger Season at the national level
  * Per. of All LIHTC Projects - Percentage of total frequency of LIHTC projects by binned frequency of heat alerts during the 2024 Danger Season at the national level
 
* heat in LIHTC - (state)
   * state - two-letter abbreviation for state
   * Frequency of Danger Season Heat Alerts (2024) - Binned frequency of heat alerts during the 2024 Danger Season at the state level
   * Frequency of LIHTC Projects - Total frequency of LIHTC projects by binned frequency of heat alerts during the 2024 Danger Season at the state level
   * Per. of All LIHTC Projects - Percentage of total frequency of LIHTC projects by binned frequency of heat alerts during the 2024 Danger Season at the state level
  

